|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
I think it was Dave_L who posted this MySQL command at the info pop board:
UPDATE w3t_Posts
SET B_File = NULL
WHERE B_Number = xxxxxx
You simply insert the post number and it removes the attachment in that post.
It would be cool to have a "remove attachment" button in "editpost.php" that ran this code... inserting the post number of course.
Beyond my ability right now. But should be part of the main release.
|
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
|
Addict
Joined: Apr 2002
Posts: 1,768 |
Keep in mind that that MySQL query only updates the database. The actual attachment file also needs to be deleted from the server.
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Thanks -
Easy enough... but good to know.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 253
Joined: January 2000
|
|
|
Forums63
Topics37,583
Posts293,955
Members13,824
| |
Most Online151,614
Nov 14th, 2025
|
|
Currently Online 435
Topics Created 0
Posts Made 0
Users Online 1
Birthdays 18
|
|
|
|
|
|
